Peachtree Integration

The NetForum integration for Peachtree accounting is a simple export of G/L information from the NetForum batch and be imported into Peachtree accounting by the client.

Setting Up Peachtree

Integration Classification

Class A - Baseline

Preferred Partners provide products or services that are integrated directly into the baseline NetForum product. These integrations are developed and supported by Abila R&D. Product interface requirements will be tracked and adjustments made to baseline as required maintaining compatibility with the integrated product.

Class A integrations are available for a fixed SAAS payment.

In some cases, a minimal configuration charge may be required to cover any setup or customization effort (i.e. generally <4 hrs.) required to implement a class A integration. Most class A integrations are set up via a system option.

In some cases a separate agreement will be required between the Abila customer and the integration partner. In other instances, Abila will be able to make all arrangements.

In a few cases, ongoing usages fees will be required by the integration partner in addition to the fees paid to Abila.

Client Tasks/Requirements

  1. Client needs to have PeachTree accounting software installed
  2. Client needs to have knowledge about how to import G/L files into PeachTree

Abila Tasks

This integration requires System Option setup.

Baseline File Layout

A sample baseline Peachtree summary format is shown below: 

 batch date,batch name,batch date,4,GL#,Act name,amount(+ dbt/-crd),,FALSE,Act Period,1
 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,1340.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,3200000000,Deferred Membership Revenue,-120.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4300000000,Event Revenue,-1190.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4400000000,Product Revenue,-30.00,,FALSE,200906,1
   

Sample File Layout for summary system option 

 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,1340.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,3200000000,Deferred Membership Revenue,-120.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4300000000,Event Revenue,-1190.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4400000000,Product Revenue,-30.00,,FALSE,200906,1
   

A sample baseline Peachtree export detail file in detail format is shown below: 

 batch date,batch name,batch date,4,GL#,Act name,amount(+ dbt/-crd),,FALSE,Period,1 
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,495.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,120.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,495.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,120.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,695.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,695.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,-15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,-120.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4400000000,Product Revenue,-15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4400000000,Product Revenue,-15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4300000000,Event Revenue,-495.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4300000000,Event Revenue,-695.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,3200000000,Deferred Membership Revenue,-120.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,-15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,-495.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,-695.00,,FALSE,200906,1
   

Sample File 

 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,495.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,120.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,495.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,120.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,1010000000,Visa/MC Clearing Account,695.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,695.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,-15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,-120.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4400000000,Product Revenue,-15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4400000000,Product Revenue,-15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4300000000,Event Revenue,-495.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,4300000000,Event Revenue,-695.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,3200000000,Deferred Membership Revenue,-120.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,-15.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,-495.00,,FALSE,200906,1
 06/17/2009,BATCHNAME,06/17/2009,4,2000000000,Accounts Receivable,-695.00,,FALSE,200906,1
   

When the BatchExportMethod is set to detail the detail export file will contain a row for each ledger record created from the batch close process. When the BatchExportMethod is set to summary only one row will appear in the detail export file for each unique GL Account. Generally Abila recommends exporting in summary rather than detail.

Usage and Instructions

Once the file is generated after the post batch process from the NetForum batch profile, staff should go to Peachtree and import the file.

Additional Services

If the file layout shown above does not meet client's requirement and client requires Abila to make such change, additional fee will be needed to perform such change. The additional fee will be based on the complexity and the content of the file layout.

Tip: This process requires that you modify the BatchExportMethod system option.